﻿SET IDENTITY_INSERT [dbo].[FamilyMaster] ON
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (1, N'Brother', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (2, N'Sister', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (3, N'Father', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (4, N'Mother', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (5, N'Husband', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (6, N'Wife', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (7, N'Uncle', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (8, N'Aunt', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (9, N'Nephew', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (10, N'Niece', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (11, N'Cousin', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (12, N'Cousin', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (13, N'Grandfather', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (14, N'Grandmother', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (15, N'Grandson', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (16, N'Granddaughter', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (17, N'Stepfather', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (18, N'Stepmother', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (19, N'Stepbrother', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (20, N'Stepsister', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (21, N'Brother-in-law', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (22, N'Sister-in-law', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (23, N'Father-in-law', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (24, N'Mother-in-law', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (25, N'Son-in-law', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (26, N'Daughter-in-law', N'female')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (27, N'Partner', N'male')
INSERT [dbo].[FamilyMaster] ([TitleID], [Title], [Category]) VALUES (28, N'Partner', N'female')
SET IDENTITY_INSERT [dbo].[FamilyMaster] OFF

SET IDENTITY_INSERT [dbo].[RelationMaster] ON
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (1, N'Single')
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (2, N'In a relationship')
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (3, N'Engaged')
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (4, N'Married')
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (5, N'Divorced')
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (6, N'Seperated')
INSERT [dbo].[RelationMaster] ([RelationshipID], [RelationshipTitle]) VALUES (7, N'Widowed')
SET IDENTITY_INSERT [dbo].[RelationMaster] OFF

SET IDENTITY_INSERT [dbo].[PrivacyMaster] ON
INSERT [dbo].[PrivacyMaster] ([PrivacyID], [Privacy]) VALUES (1, N'Public')
INSERT [dbo].[PrivacyMaster] ([PrivacyID], [Privacy]) VALUES (2, N'Friends')
INSERT [dbo].[PrivacyMaster] ([PrivacyID], [Privacy]) VALUES (3, N'Only Me')
SET IDENTITY_INSERT [dbo].[PrivacyMaster] OFF

SET IDENTITY_INSERT [dbo].[MediaLibrary] ON
INSERT [dbo].[MediaLibrary] ([MediaID], [MediaType], [MediaPath], [UploadedDate], [Title]) VALUES (1, 1, N'default-male.gif', CAST(0x00009E5E00000000 AS DateTime), NULL)
INSERT [dbo].[MediaLibrary] ([MediaID], [MediaType], [MediaPath], [UploadedDate], [Title]) VALUES (2, 1, N'default-female.gif', CAST(0x00009E5E00000000 AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[MediaLibrary] OFF

SET IDENTITY_INSERT [dbo].[ProfileInfo] ON
INSERT [dbo].[ProfileInfo] ([ProfileID], [FullName], [EmailID], [Password], [Gender], [BirthDay], [BirthdayPrivacy], [CurrentCity], [CurrentCityPrivacy], [HomeCity], [HomeCityPrivacy], [InterestedIn], [InterestedInPrivacy], [Languages], [LanguagesPrivacy], [AboutMe], [AboutMePrivacy], [ProfilePicID], [RelationshipStatusID], [RelationshipStatusPrivacy], [RelatedProfileID], [AniversaryDate], [ReligionView], [ReligionViewPrivacy], [PoliticalView], [PoliticalViewPrivacy], [PeopleInspired], [PeopleInspiredPrivacy], [FavQuote], [FavQuotePrivacy], [HobbiesInterest], [HobbiesInterestPrivacy], [Website], [WebsitePrivacy], [CreatedDate], [ModifiedDate], [LastLoggedInDate], [FamilyPrivacy], [FriendsPrivacy]) VALUES (1000, N'Deepak Kumar', N'test@test.com', N'hritik', N'Female', CAST(0x911E0B00 AS Date), 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, 5, NULL, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, CAST(0x00009FA400D32B6D AS DateTime), CAST(0x00009FA400D32B6D AS DateTime), CAST(0x00009FA400D32B6D AS DateTime), NULL, NULL)
SET IDENTITY_INSERT [dbo].[ProfileInfo] OFF